/*
 *    Copyright (c) 2018-2025, lengleng All rights reserved.
 *
 * Redistribution and use in source and binary forms, with or without
 * modification, are permitted provided that the following conditions are met:
 *
 * Redistributions of source code must retain the above copyright notice,
 * this list of conditions and the following disclaimer.
 * Redistributions in binary form must reproduce the above copyright
 * notice, this list of conditions and the following disclaimer in the
 * documentation and/or other materials provided with the distribution.
 * Neither the name of the pig4cloud.com developer nor the names of its
 * contributors may be used to endorse or promote products derived from
 * this software without specific prior written permission.
 * Author: lengleng (wangiegie@gmail.com)
 */

package com.excesys.exsecs.om.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.excesys.exsecs.om.dto.WarrantyMethodDto;
import com.excesys.exsecs.om.entity.OmWOrder;
import com.excesys.exsecs.om.vo.OrderVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

/**
 * 工单表
 *
 * @author weiyj
 * @date 2023-02-24 13:52:55
 */
@Mapper
public interface OmWOrderMapper extends BaseMapper<OmWOrder> {

	/**
	 * 分页查询计划信息（含关联信息）
	 * @param page 分页
	 * @param omWOrder 查询参数
	 * @return list
	 */
	IPage<OrderVo> getOrderWithRelPage(Page page, @Param("query") OmWOrder omWOrder);

	IPage<OrderVo> getRepairOrderWithRelPage(Page page, @Param("query") OmWOrder omWOrder);

	IPage<OrderVo> getMaintenanceOrderWithRelPage(Page page, @Param("query") OmWOrder omWOrder);

	IPage<OrderVo> getOrderWithRel8Page(Page page, @Param("query") OmWOrder omWOrder);

	IPage<OrderVo> getRepairOrderWithRel8Page(Page page, @Param("query") OmWOrder omWOrder);

	IPage<OrderVo> getMaintenanceOrderWithRel8Page(Page page, @Param("query") OmWOrder omWOrder);

	IPage<OrderVo> getOrderWithRelTodayPage(Page page, @Param("query") OmWOrder omWOrder);

	IPage<OrderVo> getRepairOrderWithRelTodayPage(Page page, @Param("query") OmWOrder omWOrder);

	IPage<OrderVo> getMaintenanceOrderWithRelTodayPage(Page page, @Param("query") OmWOrder omWOrder);

	Map<String, String> getOrderCountMap(@Param("userId") Long userId, @Param("createUserId") Long createUserId,
			@Param("evaluateUserId") Long evaluateUserId);

	Map<String, String> getOrderCountByTimeType(@Param("timeType") String timeType);

	List<Map<String, String>> getOrderCountByYearMonth();

	List<Map<String, String>> getOrderCountByDeviceType(@Param("month") String month);

	Map<String, String> getOrderByYear();

	Map<String, String> getOrderByMouth();

	Map<String, String> getOrderByDay();

	Map<String, BigDecimal> getWarrantyByYear();

	Map<String, BigDecimal> getWarrantyByMouth();

	Map<String, BigDecimal> getWarrantyByDay();

	List<WarrantyMethodDto> getRepairByYear();

	List<WarrantyMethodDto> getRepairByLastYear();

	List<WarrantyMethodDto> getRepairByToday();

	List<WarrantyMethodDto> getRepairByYesterday();

	List<WarrantyMethodDto> getRepairByMonth();

	List<WarrantyMethodDto> getRepairByLastMonth();

	OmWOrder getByOrderNo(String no);

	IPage<OmWOrder> getHomepage(Page page,  @Param("query") OmWOrder omWOrder);

}
